<?PHP
/*********************************************************************************
 * SugarCRM is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2010 SugarCRM Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
/**
 * THIS CLASS IS FOR DEVELOPERS TO MAKE CUSTOMIZATIONS IN
 */
require_once('modules/edanz_ScheduleNotes/edanz_ScheduleNotes_sugar.php');
class edanz_ScheduleNotes extends edanz_ScheduleNotes_sugar {
	
	function edanz_ScheduleNotes(){	
		parent::edanz_ScheduleNotes_sugar();

                global $moduleAssocFieldsArray;
                $moduleAssocFieldsArray['edanz_ScheduleNotes'] = array(
                     'related_editor_id' =>
                     array('table_name' => 'users',
                           'select_field_name' => 'user_name',
                           'select_field_join'  => 'id',
                          ),
                );
	}
	
        function save($check_notify = FALSE){
                //The pre_save code wasn't handling date field formats properly, so I'm re-setting those here before the save.
                require_once('include/SugarFields/SugarFieldHandler.php');
                $sfh = new SugarFieldHandler();
                foreach($this->field_defs as $field => $properties) {
                        if($properties['type'] == 'date'){
                                $sf = $sfh->getSugarField('date', true);
                                if($sf != null){
                                        $sf->save($this, $_POST, $field, $properties);
                                }
                        }
                }


                // prevent notifications when saving
                $id = parent::save(FALSE);
                return $id;
        }

        function get_list_view_data(){
                $schedulenotes_fields = $this->get_list_view_array();
                $query = "select first_name, last_name, related_editor_id from users, edanz_schedulenotes where users.id = edanz_schedulenotes.related_editor_id and edanz_schedulenotes.id ='".$this->id."'";
                $result = $this->db->query($query);
                if ( $row = $this->db->fetchByAssoc($result) )
                {
                        $schedulenotes_fields['RELATED_EDITOR_NAME'] = $row['first_name'].' '.$row['last_name'];
                        $schedulenotes_fields['RELATED_EDITOR_ID'] = $row['related_editor_id'];
                }
                return $schedulenotes_fields;
        }

}
?>
